Spread ASP.NET 6.0 Product Documentation
Group(SortInfo[],IComparer) Method
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > GroupDataModel Class > Group Method : Group(SortInfo[],IComparer) Method


sortInfo
Sort information
groupComparer
Comparer

Glossary Item Box

Groups the rows with the specified sort information and specified comparer.

Syntax

Visual Basic (Declaration) 
Public Overloads Sub Group( _
   ByVal sortInfo() As SortInfo, _
   ByVal groupComparer As IComparer _
) 
Visual Basic (Usage)Copy Code
Dim instance As GroupDataModel
Dim sortInfo() As SortInfo
Dim groupComparer As IComparer
 
instance.Group(sortInfo, groupComparer)
C# 
public void Group( 
   SortInfo[] sortInfo,
   IComparer groupComparer
)

Parameters

sortInfo
Sort information
groupComparer
Comparer

Example

This example groups the data model.
C#Copy Code
private void button1_Click(object sender, EventArgs e)
{
FarPoint.Web.Spread.Model.GroupDataModel gm = new FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel);
FarPoint.Web.Spread.SortInfo[] sort = new FarPoint.Web.Spread.SortInfo[1];
sort[0] = new FarPoint.Web.Spread.SortInfo(0, true);
gm.Group(sort, System.Collections.Comparer.Default);
FpSpread1.ActiveSheetView.DataModel = gm;

String msg = gm.Groups.Count.ToString();
Response.Write("alert('" + msg + "')");
}
Visual BasicCopy Code
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim gm As New FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel)
Dim sort(0) As FarPoint.Web.Spread.SortInfo
sort(0) = New FarPoint.Web.Spread.SortInfo(0, True)
gm.Group(sort, System.Collections.Comparer.Default)
FpSpread1.ActiveSheetView.DataModel = gm
String msg = gm.Groups.Count.ToString();
Response.Write("alert('" & msg & "')");
End Sub

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.